

package io.code.utils;

import io.code.entity.ColumnEntity;
import io.code.entity.TableEntity;
import org.apache.commons.configuration.Configuration;
import org.apache.commons.configuration.ConfigurationException;
import org.apache.commons.configuration.PropertiesConfiguration;
import org.apache.commons.io.IOUtils;
import org.apache.commons.lang.StringUtils;
import org.apache.commons.lang.WordUtils;
import org.apache.velocity.Template;
import org.apache.velocity.VelocityContext;
import org.apache.velocity.app.Velocity;

import java.io.File;
import java.io.IOException;
import java.io.StringWriter;
import java.util.*;
import java.util.zip.ZipEntry;
import java.util.zip.ZipOutputStream;

/**
 * 代码生成器   工具类
 */
public class GenUtils {

    public static List<String> getTemplates() {
        List<String> templates = new ArrayList<String>();
//		templates.add("template/DTO.java.vm");
        templates.add("template/Req.java.vm");
        templates.add("template/Entity.java.vm");
        templates.add("template/Dao.java.vm");
        templates.add("template/Dao.xml.vm");
        templates.add("template/Service.java.vm");
        templates.add("template/ServiceImpl.java.vm");
//		templates.add("template/Controller.java.vm");
//		templates.add("template/Excel.java.vm");
//		templates.add("template/index.vue.vm");
//		templates.add("template/add-or-update.vue.vm");
//		templates.add("template/mysql.vm");
//		templates.add("template/sqlserver.vm");
//		templates.add("template/oracle.vm");
//		templates.add("template/postgresql.vm");
        return templates;
    }

    public static String getGeneratedString(Map<String, String> table,
                                            List<Map<String, String>> columns, String template) {
        Map<String, String> map = generatorCode(table, columns, null);
        String result = map.get(template);
        if (result != null) {
            return result;
        }
        for (Map.Entry<String, String> entry : map.entrySet()) {
            if (entry.getKey().contains(template)) {
                return entry.getValue();
            }
        }
        return "";
    }

    /**
     * 生成代码
     */
    public static Map<String, String> generatorCode(Map<String, String> table,
                                     List<Map<String, String>> columns, ZipOutputStream zip) {
        //配置信息
        Configuration config = getConfig();
        boolean hasBigDecimal = false;
        //表信息
        TableEntity tableEntity = new TableEntity();
        tableEntity.setTableName(table.get("tableName"));
        tableEntity.setComments(table.get("tableComment"));
        //表名转换成Java类名
        String className = tableToJava(tableEntity.getTableName(), config.getString("tablePrefix"));
        tableEntity.setClassName(className);
        tableEntity.setClassname(StringUtils.uncapitalize(className));

        //列信息
        List<ColumnEntity> allColumns = new ArrayList<>();
        List<ColumnEntity> columnsList = new ArrayList<>();
        List<ColumnEntity> pksList = new ArrayList<>();
        for (Map<String, String> column : columns) {
            ColumnEntity columnEntity = new ColumnEntity();
            columnEntity.setColumnName(column.get("columnName"));
            columnEntity.setDataType(column.get("dataType"));
            columnEntity.setComments(column.get("columnComment"));
            columnEntity.setExtra(column.get("extra"));

            //列名转换成Java属性名
            String attrName = columnToJava(columnEntity.getColumnName());
            columnEntity.setAttrName(attrName);
            columnEntity.setAttrname(StringUtils.uncapitalize(attrName));

            //列的数据类型，转换成Java类型
            String attrType = config.getString(columnEntity.getDataType(), "unknowType");
            columnEntity.setAttrType(attrType);
            if (!hasBigDecimal && attrType.equals("BigDecimal")) {
                hasBigDecimal = true;
            }
            //是否主键
            if ("PRI".equalsIgnoreCase(column.get("columnKey")) && tableEntity.getPk() == null) {
                tableEntity.setPk(columnEntity);
                pksList.add(columnEntity);
            } else {
                columnsList.add(columnEntity);
            }

            allColumns.add(columnEntity);
        }
        tableEntity.setColumns(columnsList);
        tableEntity.setAllColumns(allColumns);
        tableEntity.setPks(pksList);

        //没主键，则第一个字段为主键
        if (tableEntity.getPk() == null) {
            tableEntity.setPk(tableEntity.getColumns().get(0));
        }

        //设置velocity资源加载器
        Properties prop = new Properties();
        prop.put("file.resource.loader.class" , "org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader");
        Velocity.init(prop);

        //封装模板数据
        Map<String, Object> map = new HashMap<>();
        map.put("random" , new Random());
        map.put("tableName" , tableEntity.getTableName());
        map.put("comments" , tableEntity.getComments());
        map.put("pk" , tableEntity.getPk());
        map.put("pks" , tableEntity.getPks());
        map.put("className" , tableEntity.getClassName());
        map.put("classname" , tableEntity.getClassname());
        map.put("pathName" , tableEntity.getClassname().toLowerCase());
        map.put("columns" , tableEntity.getColumns());
        map.put("allColumns", tableEntity.getAllColumns());
        map.put("hasBigDecimal" , hasBigDecimal);
        map.put("version" , config.getString("version"));
        map.put("package" , config.getString("package"));

        map.put("entityPackage" , config.getString("entityPackage"));
        map.put("daoPackage" , config.getString("daoPackage"));
        map.put("servicePackage" , config.getString("servicePackage"));
        map.put("serviceImplPackage" , config.getString("serviceImplPackage"));
        map.put("controllerPackage" , config.getString("controllerPackage"));
        map.put("reqPackage" , config.getString("reqPackage"));

        map.put("moduleName" , config.getString("moduleName"));
        map.put("author" , config.getString("author"));
        map.put("email" , config.getString("email"));
        map.put("datetime" , DateUtils.format(new Date(), DateUtils.DATE_TIME_PATTERN));
        map.put("date" , DateUtils.format(new Date(), DateUtils.DATE_PATTERN));

        for (int i = 0; i <= 10; i++) {
            map.put("id" + i, IdWorker.getId());
        }

        VelocityContext context = new VelocityContext(map);

        HashMap<String, String> result = new HashMap<>();

        //获取模板列表
        List<String> templates = getTemplates();
        for (String template : templates) {
            //渲染模板
            StringWriter sw = new StringWriter();
            Template tpl = Velocity.getTemplate(template, "UTF-8");
            tpl.merge(context, sw);


            try {
                String data = sw.toString();
                result.put(template, data);

                if (zip != null) {
                    //添加到zip
                    zip.putNextEntry(new ZipEntry(getFileName(template, tableEntity.getClassName(), config.getString("package"), config.getString("moduleName"))));
                    IOUtils.write(data, zip, "UTF-8");
                    IOUtils.closeQuietly(sw);
                    zip.closeEntry();
                }
            } catch (IOException e) {
                throw new RenException("渲染模板失败，表名：" + tableEntity.getTableName(), e);
            }

        }

        return result;
    }


    /**
     * 列名转换成Java属性名
     */
    public static String columnToJava(String columnName) {
        return WordUtils.capitalizeFully(columnName, new char[]{'_'}).replace("_" , "");
    }

    /**
     * 表名转换成Java类名
     */
    public static String tableToJava(String tableName, String tablePrefix) {
        if (StringUtils.isNotBlank(tablePrefix)) {
            tableName = tableName.startsWith(tablePrefix) ? tableName.replaceFirst(tablePrefix, "") : tableName;
        }
        return columnToJava(tableName);
    }

    /**
     * 获取配置信息
     */
    public static Configuration getConfig() {
        try {
            return new PropertiesConfiguration("generator.properties");
        } catch (ConfigurationException e) {
            throw new RenException("获取配置文件失败，" , e);
        }
    }

    /**
     * 获取文件名
     */
    public static String getFileName(String template, String className, String packageName, String moduleName) {
        String packagePath = /*"main" + File.separator + "java" + File.separator + */"";
        if (StringUtils.isNotBlank(packageName)) {
            packagePath += packageName.replace("." , File.separator) + /*File.separator + "modules" + File.separator +*/ moduleName + File.separator;
        }

        if (template.contains("Req.java.vm")) {
			return packagePath + "req" + File.separator + className + "Req.java";
        }

        if (template.contains("Entity.java.vm")) {
            return packagePath + "entity" + File.separator + className + ".java";
        }

        if (template.contains("Excel.java.vm")) {
            return packagePath + "excel" + File.separator + className + "Excel.java";
        }

        if (template.contains("Dao.java.vm")) {
            return packagePath + "dao" + File.separator + className + "Dao.java";
        }

        if (template.contains("Service.java.vm")) {
            return packagePath + "service" + File.separator + className + "Service.java";
        }

        if (template.contains("ServiceImpl.java.vm")) {
            return packagePath + "service" + File.separator + "impl" + File.separator + className + "ServiceImpl.java";
        }

        if (template.contains("Controller.java.vm")) {
            return packagePath + "controller" + File.separator + className + "Controller.java";
        }

        if (template.contains("Dao.xml.vm")) {
            return/* "main" + File.separator + "resources" + File.separator +*/ "mapper" + File.separator + moduleName + File.separator + className + "DaoMapper.xml";
        }

        if (template.contains("DTO.java.vm")) {
            return packagePath + "dto" + File.separator + className + "DTO.java";
        }

        if (template.contains("index.vue.vm")) {
            return "vue" + File.separator + "views" + File.separator + "modules" +
                    File.separator + moduleName + File.separator + className.toLowerCase() + ".vue";
        }

        if (template.contains("add-or-update.vue.vm")) {
            return "vue" + File.separator + "views" + File.separator + "modules" +
                    File.separator + moduleName + File.separator + className.toLowerCase() + "-add-or-update.vue";
        }

        if (template.contains("mysql.vm")) {
            return className.toLowerCase() + ".mysql.sql";
        }

        if (template.contains("oracle.vm")) {
            return className.toLowerCase() + ".oracle.sql";
        }

        if (template.contains("sqlserver.vm")) {
            return className.toLowerCase() + ".sqlserver.sql";
        }

        if (template.contains("postgresql.vm")) {
            return className.toLowerCase() + ".postgresql.sql";
        }

        return null;
    }
}
